﻿using System;
using System.Data;
using System.Collections;
using System.Collections.Specialized;
using WP.DB;
using WP.RM.DataEntity;
using WP.Commons;
namespace WP.RM.DataAccess
{
    public class RMProductDAL : IDataAccess
    {
        public RMProductDAL()
		{
		}
        #region Select List
        public string SQLList(int iParameter)
        {
            string strSQL = @"SELECT RecId, ProductID,ProductName,CategoryID,CategoryName,SetID,SetName,Productlength,ProductWidth,Pages,Remark,ProductFItemID FROM rmProduct order by ProductID ";
            return strSQL;
        }
        #endregion

        #region Fields
        public string Fields
        {
            get
            {
                return @"  ProductFItemID,ProductID,ProductName,CategoryID,CategoryName,SetID,SetName,Productlength,ProductWidth,Pages,Remark,PaperHeight,Ver,Quantity,SetSize
                           ,LabelUnitQty,LabelLength ,LabelWidth,LabelSize ,PrintLength ,PrintWidth ,LaminatingLength ,LaminatingWidth ,CutFactor
                           ,PrintUseQty ,ContainQty ,PackageQty ,InnerDiameterLength ,InnerDiameterWidth ,InnerDiameterHeight ,InnerOutsideDiff ,MiddleWidth
                           ,BurrWidth ,OtherPrintWidth ,OtherPrintBackWidth ,UseIronNailQty ,LockingWireQty ,LockingWireLength,KDCode,PagePrintWidth,PagePrintLength,ProdDiameter ";
            }
        }
        #endregion
    }
}
